<%@ page language="java" import="java.util.*" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312"%>
<%@page import="com.db_conn.*" %>
 <%@page import="java.sql.*" %>
 
<%
   
   	
    try{
    	
    ConnMysql fac=new ConnMysql();
    Connection conn=fac.Get_Connection();
    JDBC_Executor exec=new JDBC_Executor(conn);
    String sql="select * from test";
    exec.Insert("insert into test values('1')");
    ResultSet rs=exec.Select(sql);
   
    
    int i=1;
    out.println("<table border='1'>");
    while(rs.next()){
    	
    out.println("<tr><td>"+rs.getString("name")+"</td></tr>");
    i++;
    }
    out.println("</table>");
    } catch(Exception e)
	   { 
		   System.out.println(e.getMessage());

	   }    
 %>